UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6BZsYrOWa76+/pbDe7ivfRTLBEL0stP6pwyj1Ve1sEU='
WHERE
key_id = 'ea9abac0b2ad5ca5cef6e66916dd123be031a023fc2b06c5ea6e8a9549bf1a04'
AND (
token = '6BZsYrOWa76+/pbDe7ivfRTLBEL0stP6pwyj1Ve1sEU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)