UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LnN0OYEZzY0Fb8sp78w8mfobvZNL1RFLo/eS3i0Pgus='
WHERE
key_id = '8b3526753ad7fff12e8cc459ee600eb305c291e1e06b9ec1ca9a7a10037585d7'
AND (
token = 'LnN0OYEZzY0Fb8sp78w8mfobvZNL1RFLo/eS3i0Pgus='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)