UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '47zhpcaWZHXaY+UXlp3mO9KiAdI/ElvaE36JUXnsGwg='
WHERE
key_id = '07a0911cb6ee544da3f3bb91b40b2596836b4a5b16b32af619e3b06a2894c841'
AND (
token = '47zhpcaWZHXaY+UXlp3mO9KiAdI/ElvaE36JUXnsGwg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)