UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 't7+ZMRAFhig+rLXZb6MO9xpsuFiESs+6X5g4aeK8NZs='
WHERE
key_id = 'edd05e8d8be845f6dc9c061da66ddc9bfa1ec32347f23ac4020c73e7e36f921d'
AND (
token = 't7+ZMRAFhig+rLXZb6MO9xpsuFiESs+6X5g4aeK8NZs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)