UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9RHCDF+7bP9shWcJfl7jLBNJGvSj6x8BmBo4Qye8JfI='
WHERE
key_id = 'bcb246d39bcc9fd7356586bfed1cf1ad43fe1833a1267e593a8a0a0099d2956b'
AND (
token = '9RHCDF+7bP9shWcJfl7jLBNJGvSj6x8BmBo4Qye8JfI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)