UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'x1rXFqSEb/cF1PVA3TkEIaX8hbLSqf3WWft96MXLGrY='
WHERE
key_id = 'f06e3e7d0ce8b97cd28cab9dd0b07c3855723f8124564e1824daf648c5039326'
AND (
token = 'x1rXFqSEb/cF1PVA3TkEIaX8hbLSqf3WWft96MXLGrY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)