UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6ZoF9E7t1plBWOnZ1pxLuOsl/b4Ckh0+67I+fq2pByc='
WHERE
key_id = 'b3af31aafe424dcec4a06a3daa7649e1d2f95df55ec91bfaa331f22daaa0b69d'
AND (
token = '6ZoF9E7t1plBWOnZ1pxLuOsl/b4Ckh0+67I+fq2pByc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)