UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CsxHuQ/xu2TORFk6klfCqcoAbuPBwJnLPxU3I86HwGs='
WHERE
key_id = 'd9c29d3aac57fb92609cebacd690fcb97eb88985e428738f3eb136bcacdbc6d5'
AND (
token = 'CsxHuQ/xu2TORFk6klfCqcoAbuPBwJnLPxU3I86HwGs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)