UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'n0IwtVLqQeC6ktRbKdaTljmqIKXgmHImFLbM6+Vbv6A='
WHERE
key_id = '1e2e49b84d86428c4fae89a703e6a9d7853ed7a459e2338f05214d05b6df9a83'
AND (
token = 'n0IwtVLqQeC6ktRbKdaTljmqIKXgmHImFLbM6+Vbv6A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)