UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'htZQKuUk2Q3A4D8Lk2Kv3/m0JHFUP1bG1WTIFkBihOc='
WHERE
key_id = '9d09bac1e83343b6cecac47511d29bffeaf74b333d6e6fb12a2bb639b3bb1ea7'
AND (
token = 'htZQKuUk2Q3A4D8Lk2Kv3/m0JHFUP1bG1WTIFkBihOc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)