UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TlGBQaX4uOpsC6iUEfTAZkrBJUOG3PDk4KXgVdnsM6k='
WHERE
key_id = 'a2f50bad812ea4601864a887164e96e3f71fd4ab5ee3a0a9f11791e0e3ca77ad'
AND (
token = 'TlGBQaX4uOpsC6iUEfTAZkrBJUOG3PDk4KXgVdnsM6k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)