UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'upEH/7kPj1cah7mMuQcT3OhmZzQQ0CYnsggOhe2fBhQ='
WHERE
key_id = 'cbca191ec5c822eab85bb22ab0eb50aeb160ea191ce33395a9db1a3a64df2c8b'
AND (
token = 'upEH/7kPj1cah7mMuQcT3OhmZzQQ0CYnsggOhe2fBhQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)