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