UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'f4G8/zC3E9DpfrRhSjf2oHhb5EMjZY6G7+IXA8NBAJs='
WHERE
key_id = '3c42ac48815a69b5e92702c30106225983ad45153b78e77ae4e4b728df49a1e7'
AND (
token = 'f4G8/zC3E9DpfrRhSjf2oHhb5EMjZY6G7+IXA8NBAJs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)