UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HBT9niThy+Qce5iKnVkOj+6pEfziJlGaXrKSOjD5JXw='
WHERE
key_id = 'c4f72a7202d9788ed9edba05e5986a52ce0556d60640749ee51ad34b72588604'
AND (
token = 'HBT9niThy+Qce5iKnVkOj+6pEfziJlGaXrKSOjD5JXw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)