UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6bDFyhthE7kwAzFm1G5QifYGcH7E2V7M/H6gvt4uFvg='
WHERE
key_id = 'd0c8a4340036f2b4898dd37656666ba7b995b5953b51ec7fde7ed0925bd87206'
AND (
token = '6bDFyhthE7kwAzFm1G5QifYGcH7E2V7M/H6gvt4uFvg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)