UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PqcNPt8ec/GKa5ImIi7dLnecYu8fcQrjwff+S5FODyo='
WHERE
key_id = '588b2570166671d1c9d784d952bfc71647dc469e5367fc8452f93a9de7817337'
AND (
token = 'PqcNPt8ec/GKa5ImIi7dLnecYu8fcQrjwff+S5FODyo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)