UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X3EsRaQDVl/xpmGb4W8dwXEv2K9b7zmTfYEj+95XKo4='
WHERE
key_id = 'bd533849bca5d94278fb7c5db47212d01b993d5309288720ef5dfb4297bb6fe2'
AND (
token = 'X3EsRaQDVl/xpmGb4W8dwXEv2K9b7zmTfYEj+95XKo4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)