UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qLrEDoh9Im4yfWkpjcT3bvshGfB2YW0A/ZHZsACprg4='
WHERE
key_id = '889a727b1c8e82637b564ae579e085717c83596ddd0541bbd2006773e58d135c'
AND (
token = 'qLrEDoh9Im4yfWkpjcT3bvshGfB2YW0A/ZHZsACprg4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)