UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JmJt0zWnPmJ5870wCYJRZszhM50YOajoWvEMiGKyNEM='
WHERE
key_id = '4b8e0491d3c84104ded8d25affe47615648d5ac316e233a8b26b220647511f77'
AND (
token = 'JmJt0zWnPmJ5870wCYJRZszhM50YOajoWvEMiGKyNEM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)