UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rSL6vRdVDJuMfZI+0IienHxQkiq89ZQcmCbmVy4whac='
WHERE
key_id = 'a8ba66143bc12cc515744b8006bc0eecf88da03cc87e335f2431d6eeb7b5fc45'
AND (
token = 'rSL6vRdVDJuMfZI+0IienHxQkiq89ZQcmCbmVy4whac='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)