UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nXlTkOhC1sh+c61wCaLNt/pTKH9Y/Jc7DEkOuvRIbuA='
WHERE
key_id = '9ae8f73ad55fd73e06f06be4f780e39af6863516066b91a6859ef67ff67b3641'
AND (
token = 'nXlTkOhC1sh+c61wCaLNt/pTKH9Y/Jc7DEkOuvRIbuA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)