UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zG2uqnb5eVuhWWi74+e5l6R+PSIWhX592T664Y3a7KU='
WHERE
key_id = '051c0f3a697447ea2d4dfa245693038ef957e408a8cce8156378855bd97af3d5'
AND (
token = 'zG2uqnb5eVuhWWi74+e5l6R+PSIWhX592T664Y3a7KU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)