UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1nSznRJnZ0VSj0dU3zYc+XPGmFFXozJK7xAcDX5jY3k='
WHERE
key_id = 'd22afeddc2729812106cfd774e9b84101d8f98e1f341ee0ba98e0732f8385124'
AND (
token = '1nSznRJnZ0VSj0dU3zYc+XPGmFFXozJK7xAcDX5jY3k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)