UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LiJJivn88Bc7FbqRueEIh3CS8vzYskHKn3DJkpbJZY8='
WHERE
key_id = '9549c96860cf1e16f694f8767e911b32f38f94ffa479a3e1a337777f3d057597'
AND (
token = 'LiJJivn88Bc7FbqRueEIh3CS8vzYskHKn3DJkpbJZY8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)