UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gu5yoJvVx0gSDwe58u8FKf+MzFvMPHYtxeWH1BaifCk='
WHERE
key_id = 'c0d5b69494f1f9996c968e876b8fa0afa65ce223acb7291857bb2ad6e1619ae1'
AND (
token = 'gu5yoJvVx0gSDwe58u8FKf+MzFvMPHYtxeWH1BaifCk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)