UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vcz1WPll8z5rDMRI/t5UxhXECBgyBFnAD8ToungR7U8='
WHERE
key_id = 'c9f013c6633d4a3f99e02e17b06efe77a70c1765d6055a8ec8f78839649a590a'
AND (
token = 'vcz1WPll8z5rDMRI/t5UxhXECBgyBFnAD8ToungR7U8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)