UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'L4bdmLim2RYXaiE6ll/ivIVZeGf2sYwV91IEjtlchv8='
WHERE
key_id = 'c7d9544d6919589802f813bc4142a27b631c9c4ad70b316667c0f5901475fdcb'
AND (
token = 'L4bdmLim2RYXaiE6ll/ivIVZeGf2sYwV91IEjtlchv8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)