UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'q1ymGNiF4BLyLJxwvFIjp/9xE4BU1S38HWxFtt9Ereg='
WHERE
key_id = 'a52fbaf9a5f6a6ce86056e99107e2de2bb2fdc693e8a1814ca837382c9a551ad'
AND (
token = 'q1ymGNiF4BLyLJxwvFIjp/9xE4BU1S38HWxFtt9Ereg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)