UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'w30kxjPSoHWF94T2Zh2FB/hdVBAdI8oxDaya7kBnn+Q='
WHERE
key_id = 'a6506ff80243973cd9675dfd121f6f27c57f210c91826d24bf966c2425a85aab'
AND (
token = 'w30kxjPSoHWF94T2Zh2FB/hdVBAdI8oxDaya7kBnn+Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)