UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zqVj7ZSlKM/Jf/F/SDTjYAyq2WeTiyBXTvG/d/kyZnE='
WHERE
key_id = '1f8f9e42108f9a81c78c852660e69d81fc938205c3f1305a502a07ec32ef74b1'
AND (
token = 'zqVj7ZSlKM/Jf/F/SDTjYAyq2WeTiyBXTvG/d/kyZnE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)