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