UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qVvEDCXodt4CegYIwqjNBfAnyRuBvbgTRKOj6Q7nWzo='
WHERE
key_id = 'f51115c752e6cf81f1a204515768faa1053614510a7cbb39e6d95229befd0294'
AND (
token = 'qVvEDCXodt4CegYIwqjNBfAnyRuBvbgTRKOj6Q7nWzo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)