UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'I+ozbBInU3jGGj37l5HulIEVG17bOq+hoWVsCd/zZ+A='
WHERE
key_id = 'f6635a4f54f8c06d5e55d6d4a1c2b74171cf9b5992620d9b1f32aefa0427a19d'
AND (
token = 'I+ozbBInU3jGGj37l5HulIEVG17bOq+hoWVsCd/zZ+A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)