UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'k1RoFlDpyV1utNWv98q/9L72e4m+hO17NlY1vKu/3Rw='
WHERE
key_id = '07c499bca67d9b9bc68a7a46a721c71bc876d53776661a36e414caf087923408'
AND (
token = 'k1RoFlDpyV1utNWv98q/9L72e4m+hO17NlY1vKu/3Rw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)