UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'eZyxJVMUsvHi8IzKw31UHDq/g20O1GX05JhTp1fSZ3g='
WHERE
key_id = 'bc803219e96f2ce434b0ceb9809a0f46cbfc079dae6fcdbc9114b47f8120640e'
AND (
token = 'eZyxJVMUsvHi8IzKw31UHDq/g20O1GX05JhTp1fSZ3g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)